/***********************************************************************************************************************************
 * Name:	PublishDB.sql
 * Author:	Frank Figearo (frank.figearo@us.bbaaviation.com|frank@sqlnerd.me)
 * Summary:	
 */
SET IMPLICIT_TRANSACTIONS OFF; IF 0 < @@TRANCOUNT ROLLBACK;
GO
USE [$(DBName)];
EXECUTE sp_replicationdboption @dbname= N'$(DBName)', @optname= N'Publish', @value= N'TRUE';
EXECUTE sp_addlogreader_agent @job_login= N'$(JobLogin)', @job_password= N'$(JobPassword)';
GO